SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339631 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339631 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719315,627845,972219,549538,51276,116119,538092,216800,1042426,569730,44056,914765,508263,201912,1004355,434180,330349,642434,706980,358662,262398,175137,41943,929677,914008,729975,130013,443697,111794,104782,10814,349650,882502,961841,8467,496275,631509,429926,1024759,1017231,421064,107627,499637,630729,629348,764632,602097,564022,1004318,747493,212820,647601,905317,320644,529787,728100,251234,670428,976988,949670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]