SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043482 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043482 [ RunTime:0.002576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130420,675143,729825,1019925,202414,570211,208165,927482,72024,1012928,596365,999372,583963,635476,822699,620705,640553,7585,60968,307239,182948,897923,338825,986770,757175,770661,638905,841219,414093,188418,865663,82501,634416,1037821,654203,986626,489286,301203,907060,666884,662541,366346,160854,764693,80625,957400,281135,364517,622500,241826,1029298,993684,1024709,807167,141202,787509,167402,520393,339801,993032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]