SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001976s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192012 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192012 [ RunTime:0.002787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302251,535717,727568,511207,13162,528990,139142,135275,337789,284793,61353,63779,933465,783741,779420,839025,922424,802937,443018,588639,633060,177319,622178,201572,76775,618467,831921,684145,142668,31391,681801,576231,47525,200749,539196,710508,562970,574661,821815,767930,55648,56248,725510,752216,412534,389200,331809,603351,948416,289678,361119,553323,588107,952562,367730,74165,27532,791964,47180,930556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002309s ]