SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194057 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194057 [ RunTime:0.002890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148943,973059,231832,126850,183174,1042649,737801,1021334,693737,164135,497473,835430,604700,522630,354406,648670,571565,951302,500190,818114,298384,409687,679054,759991,980285,376181,887872,87226,584265,931207,81605,17828,182057,191115,511677,135579,206901,481971,18462,697200,30334,33526,171376,802751,32276,448143,647787,709646,817786,67618,719472,568756,136608,297009,835868,281412,986785,536710,443012,527471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]