SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34850 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34850 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713216,1048405,466921,299766,166089,1023896,925624,689076,307860,456697,775577,798607,66427,617229,886632,318066,1032632,977795,352151,151204,213437,385788,253535,102165,58568,986135,1007882,74174,282411,312149,31073,609825,946120,972636,349406,638,233763,211266,860564,943826,273,836021,706384,648435,150464,250666,52979,1046955,251881,923672,40854,806022,624871,707989,59694,650883,809543,889319,754796,104156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]