SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412777 LIMIT 1 [ RunTime:0.000984s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412777 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19109,542218,284948,801149,677059,484007,750815,1028998,785618,982702,291246,950368,252861,313853,981855,651641,86652,335484,799515,98973,91500,1026664,557519,829078,109100,581439,955505,474278,518910,594835,67245,488482,272701,308765,117380,127374,601250,93894,371000,67806,883636,109029,788824,1022382,786303,290436,539351,238352,74347,418493,124660,197844,645892,944692,576303,295304,368046,603918,910215,906719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001063s ]