SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567908 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567908 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328859,276807,668953,215733,963903,552631,901962,42001,931386,734521,398671,748643,230500,607714,766125,896050,813260,671924,95782,162384,974445,940504,41442,84570,965749,423414,153055,124830,190880,140103,177812,483527,584705,483998,405208,319424,619290,718427,82787,238509,977553,465626,879603,983866,841004,525915,424898,665644,314933,898858,782925,789487,788237,696945,461459,749871,172197,712264,444509,136099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]