SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568748 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568748 [ RunTime:0.003442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411831,292053,296121,9920,533628,1002658,506988,848341,472218,333011,912948,784946,669572,678899,564246,474456,700022,245717,677069,964162,568212,472211,5933,247452,674075,337495,273712,733607,256888,1021143,423019,980504,424491,501754,952832,81305,283687,471212,600508,9933,278734,674994,981027,1035599,551153,847988,796838,976361,918576,289152,353322,762133,78130,235926,304754,420588,582793,71802,776609,138415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]