SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506755 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506755 [ RunTime:0.002776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338711,457364,407179,912434,186165,1004286,569287,100022,897901,692873,345186,296213,583065,865987,460675,72900,977851,375711,608934,563965,304683,696920,154925,1011274,188806,983241,1016355,452384,733534,600132,668375,256790,375673,79746,803853,92204,346885,311471,58048,69950,368444,308299,768925,157369,124142,500348,140665,774747,681839,562499,575520,245415,680345,793065,174535,227294,24027,653276,173688,902188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506755 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506755 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]