SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415048 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415048 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441614,147170,198088,561231,54765,368148,213498,604328,747921,905101,648547,413799,267072,644794,330552,786725,162409,266474,665207,164521,540645,296129,209386,397434,206114,188669,983912,734563,461897,726276,88057,666841,648292,1034488,614137,957612,616545,742702,157525,166781,247136,713979,180945,34868,600386,350791,284703,935835,404885,218501,728589,817541,698953,621200,796093,458554,151484,700587,445496,1021425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001473s ]