SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027834 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027834 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709171,59908,915410,238849,807350,29159,605827,821417,777695,496673,894483,810682,570552,1022943,305984,599129,467687,1004413,633731,1046809,421503,708714,970327,528804,560615,602196,731322,70905,7249,563673,29429,669746,262650,1008400,990679,856071,227384,526676,930971,893356,750263,162735,203778,749935,200548,562248,624695,986006,58155,840291,205520,989903,284100,14923,361465,54378,280395,377050,578789,457536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]