SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026574 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026574 [ RunTime:0.004790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422433,689770,612235,359378,635951,999849,67660,386491,679240,1010845,28710,405193,638975,653069,345292,463023,627133,137433,850469,1031583,484159,354559,299232,1000556,959484,740324,741505,1551,792522,601104,847637,553943,962148,699741,191406,636330,648719,451579,681006,201264,331063,604308,445477,584895,485103,294505,554718,9563,365665,541201,620238,361842,961633,871237,121531,909519,976943,801900,309765,447074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]