SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502683 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502683 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576597,564647,741547,568071,879,451921,992868,549546,151331,974683,31808,846480,627188,500113,231731,808844,922218,873901,853330,519904,44875,410928,968854,718442,576407,676658,512858,473646,619091,899990,796650,704972,540942,1032046,1032762,794202,1012975,420713,209717,208328,920534,408386,677008,703098,200689,716753,336105,956296,891336,1024739,884765,874168,344893,778174,374280,362883,609740,551093,981276,394013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]