SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6571 LIMIT 1 [ RunTime:0.001186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6571 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568373,67774,1046999,610977,815151,418044,405438,55080,152804,349336,825750,294365,37017,242299,590886,225688,9354,605109,667849,219185,638749,371467,585746,560578,482049,588889,272756,285890,320652,950251,332743,1479,665198,321660,488289,944701,87011,245512,693627,38899,426198,243823,37085,430783,472306,934172,745811,901135,24968,760334,387187,876974,993529,481590,714310,1047311,844560,732474,966679,676669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001764s ]