SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509393 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509393 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599511,810910,817370,412776,912579,403184,632746,865313,148320,963195,375105,19474,966715,303017,1025127,1039272,835850,801953,590683,546196,820389,116234,349655,439583,124454,370839,427535,583947,858205,721994,867875,988894,603359,343317,296255,900269,1030039,810843,401107,551118,154552,716794,69280,114333,865231,880564,529559,661183,1002847,447533,575829,504126,593896,663181,485787,384798,597404,352232,937594,465226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]