SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103052 LIMIT 1 [ RunTime:0.005923s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103052 [ RunTime:0.004845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011276,981987,37163,540950,467250,1011272,812382,560110,40233,189505,635895,94071,9851,936006,655277,358121,326273,206166,393144,104681,302527,384726,228836,846457,620929,822056,798199,199446,18095,676260,515909,1041591,512222,565462,626879,412848,413639,874206,83178,1034406,763176,651799,193632,646789,759596,257174,1042005,822813,691411,753994,223021,120497,788916,250635,690007,524919,725614,228991,562634,1022013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002511s ]