SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304093 LIMIT 1 [ RunTime:0.002262s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304093 [ RunTime:0.003771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34141,515279,31587,1019952,401440,184187,710935,354560,896966,682886,719692,377199,170984,510219,775942,987829,39981,1032387,861558,393471,267451,828682,695573,647416,70749,110143,506174,373918,670208,735300,50315,296989,878701,745442,98686,361406,1021310,721394,136842,163596,542954,1029466,839255,1012931,1033513,270060,200366,752463,531874,15415,707756,27413,594622,750877,80602,400977,850065,1037946,306168,621700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]