SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39000 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39000 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208330,340818,265866,799832,362728,898219,978964,285905,1011377,476081,563044,187489,408766,672845,294642,936168,94385,101342,1037168,391848,900466,739266,727639,292887,383237,159237,422340,832308,904643,67644,910406,801938,766019,907224,888632,883096,440374,173518,514737,306902,86057,716404,914639,265056,375740,562435,824726,593007,143235,144865,662162,1026108,109461,530015,426311,39838,375592,5105,817862,12285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]