SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336883 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336883 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547263,434640,409749,536931,195794,552406,1011848,250167,54662,745593,110194,341730,98020,85343,594765,853517,1036952,960126,518783,331775,556123,492936,410771,907460,810886,164594,299803,530546,550643,408265,824513,188657,1040664,853320,468686,316225,974377,800462,520734,37044,13305,178177,645671,320275,912533,333712,912818,367080,225688,986339,993800,302183,176753,528777,364953,321580,569657,170270,641565,181942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]