SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405318 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405318 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527956,370771,737250,728739,623900,627849,678855,929784,325257,260508,802414,33503,869941,176406,111687,678963,166819,595980,825828,885844,7475,652559,923430,748531,963998,547251,710951,199122,525593,811797,361681,1014473,580416,640839,90602,101898,809714,235145,969962,475646,473391,495919,882963,822025,965990,475569,923904,798194,473854,448481,916856,198715,488405,1009061,512510,822526,792144,188425,595344,981881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]