SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048198 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048198 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331518,401040,184327,72378,653116,908613,84283,206324,143495,580397,307905,944585,542793,2607,989914,748371,768701,404034,392612,224322,322736,937190,180074,811174,480446,277921,840852,164807,411122,535362,431310,300449,526107,501884,300552,788144,281275,574047,413766,500221,709706,598274,637767,17219,880831,473963,371817,906144,347727,262,864940,31014,987585,994624,835319,523247,1007632,183318,633978,158291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]