SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101430 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101430 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104840,911700,369626,633169,380887,547987,109410,787125,1008961,380365,870243,54873,330894,77968,809831,285106,643975,397787,454188,29838,216593,517421,79528,87608,126380,786584,957781,293992,653278,486164,616486,518531,732706,330052,344266,794540,476075,902432,761613,578521,431260,58382,856589,567470,770973,43890,670307,522078,1033432,20031,1036780,999518,737053,269353,159537,197631,345467,717276,686879,301197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]