SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438751 LIMIT 1 [ RunTime:0.000724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438751 [ RunTime:0.003287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421287,734029,362689,149805,509776,165217,924816,1025082,557697,542727,251318,204990,1016701,659442,185416,33958,301546,142943,101989,770914,353442,118082,232558,511217,595344,258805,802414,481718,569472,331725,483292,165966,205098,585543,610673,723669,671984,374166,575071,272881,140487,180961,998857,1017983,847348,405293,353222,144861,773627,840085,778451,634201,274083,1010915,274778,535500,483452,492073,981969,844309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]