SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109047 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109047 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295499,142370,657036,343575,464623,123511,52524,326131,265911,973725,389113,588547,725563,222371,682236,106453,134465,769939,158180,369179,716628,569372,537554,258141,119404,163871,852132,699572,942554,638135,50047,567431,168167,401809,70634,505489,493819,905050,255064,542799,191693,414970,56601,685650,370901,728506,748092,462997,66427,478334,197871,30414,549654,485180,231764,38396,746955,181602,30225,204411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]