SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456917 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456917 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190730,441705,217880,900413,892315,719516,540634,111044,921505,178291,489880,185705,1000723,671735,917438,906384,328596,995848,1005745,310075,1001733,223447,27468,238658,198219,852742,66884,307193,1003020,346296,166187,908661,967874,493676,198181,706118,151583,694230,626009,941870,683533,178152,963578,44713,94061,455323,277732,292458,885385,136274,611812,975025,147267,480536,367532,655855,59816,769234,40704,930123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]