SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418151 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418151 [ RunTime:0.003621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203109,1013401,714193,495198,1020302,1046654,65314,678855,150032,324068,111384,162226,87015,234810,66532,439897,783225,239319,562638,753604,75083,763868,921439,902152,157066,272678,578938,223954,572413,430030,114178,156780,193990,612578,870743,499884,361578,208140,604131,652409,300166,13812,331353,347116,868366,758978,530831,849325,154517,362324,25481,566968,794378,817484,191101,969313,666768,714747,426896,403371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]