SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106245 LIMIT 1 [ RunTime:0.000783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106245 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81917,616802,713986,912548,272213,677961,354364,809333,176284,386841,741401,684766,66836,190039,1007872,374872,222866,162251,380708,780438,543465,994164,578937,837391,657997,546682,527371,267970,458558,673664,583846,277958,674960,528645,207913,603766,552961,891777,302300,799883,81919,575280,466727,969454,802360,72658,7805,705188,92579,362206,908827,53470,355122,399971,857078,277120,865579,680156,501684,465093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]