SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194983 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194983 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213614,279164,878787,754653,360593,876534,661869,975338,345184,21494,386030,235987,319825,559404,309859,513836,391941,390081,571136,245433,309895,410643,782531,863966,140247,742716,982042,13357,386353,291569,551232,603083,1016120,297111,12394,731366,678352,383598,478100,768491,264869,555184,219977,221250,185838,154446,896461,616616,386309,319115,808178,720226,186643,399366,950840,880568,824769,625341,993582,883874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]