SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429682 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429682 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703278,875007,453442,462182,182331,723732,557194,850015,5197,957120,70372,138475,154183,680798,758602,271905,479886,606840,944323,951083,212477,558978,908776,278480,758690,528088,399377,448606,415610,585289,968175,790548,401461,90477,130996,970354,366067,971877,112988,9642,720163,727449,462048,143145,649541,445643,668094,954552,1033667,790630,94982,874573,33581,276235,351786,958313,702829,440770,540526,133989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]