SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102746 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102746 [ RunTime:0.002927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101804,590337,523416,100257,634867,445107,476951,884363,207699,516093,746452,706801,556282,844031,514762,212571,413447,383958,774429,723132,75709,157201,425177,748294,580963,936112,232403,77679,88858,332300,835508,276006,1006181,195633,331025,849177,169965,93548,264835,831491,606514,938068,131363,304498,618781,69970,214830,624394,593377,498663,229258,824522,407226,436004,407436,458433,637561,213359,83335,278182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]