SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019501 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019501 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385760,855524,872460,426213,197720,632084,465786,14951,91964,491253,581311,197323,575,729694,324825,681017,653029,73728,852422,531291,413880,99542,5462,485632,170906,493603,1021011,810115,479303,972445,263378,389623,544254,1008722,199604,680798,776126,473201,874480,477052,583035,562952,766916,905794,1038736,388675,45124,760143,1023055,940214,14967,745872,624072,54097,532619,279157,674042,357226,437222,78280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]