SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38176 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38176 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614221,462422,995073,347813,944631,325878,302376,408183,354950,330501,753095,409888,634729,964019,754140,528016,211722,720698,288152,88452,726290,582193,770148,516419,937417,360075,1009993,374112,420084,408102,825052,1004136,431973,490057,792449,678784,38828,358162,307065,1042105,571405,1039831,611490,676362,947236,654740,1019831,137180,656196,470548,9444,470969,68709,1737,272229,769096,791803,729145,838015,937471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]