SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553820 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553820 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355554,765157,757676,202654,792233,645365,167666,428843,942083,971031,264450,561622,492973,844185,678282,500261,913742,171512,401014,641764,686629,164432,686160,404850,178868,1011290,768083,1009253,511533,889678,31391,1023449,781029,127831,111647,114452,13427,830523,1039198,929075,686432,599289,525648,1009426,230344,786868,689043,599778,951715,434614,954730,40437,907751,674934,111600,435531,393718,206801,785693,393081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001679s ]