SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411543 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411543 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329141,650635,61689,838854,658867,458408,656495,429829,590001,293575,434970,291950,358930,454841,966030,837473,41322,936432,548500,39570,683703,916386,845568,54169,125955,848746,382156,139565,386862,771208,274585,401773,798723,636597,654498,769680,655104,825895,743498,110005,201690,539107,947124,779320,808788,149933,163530,14137,172520,222990,1021693,40487,775320,239305,669316,585441,995964,126554,770700,1042604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001168s ]