SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920091 LIMIT 1 [ RunTime:0.002425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920091 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430771,318968,35905,103290,423143,964466,21124,409360,309982,695478,418630,157612,310488,1396,124489,715565,120031,70401,366938,427165,1001190,845461,129228,172722,322279,908738,525471,967787,49954,399702,555891,193959,47472,173818,998666,23495,642419,107074,249744,566583,201974,112837,636299,604810,866294,633845,189030,769272,836567,740529,956012,625325,996057,205228,351725,3313,700444,558205,148914,723841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]