SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189103 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189103 [ RunTime:0.003147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898038,839517,949075,278345,25691,415063,916729,635842,640604,474609,404622,1036133,555578,206467,303298,271016,870695,663277,88210,572556,515144,123601,348139,516442,826382,223047,821042,582143,987230,391824,567882,160499,220185,844777,276700,613815,935743,727442,399731,733192,218363,1003450,19434,533348,284690,102941,1022754,702498,292541,983288,45985,701327,604511,600794,290854,495114,687512,806377,786016,394403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]