SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292160 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292160 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508577,164290,763343,921933,710574,1024298,120278,499782,592463,116192,570561,984308,811675,75886,193963,330911,86250,280357,248308,17018,502610,730069,640813,231697,88681,688415,770576,989903,681727,300091,732495,131838,66717,328720,898612,952242,14246,814183,1021365,756103,933564,773302,709966,319173,709974,499831,264648,682939,943424,812758,603759,166014,752883,958780,203942,345110,578497,150085,381670,764949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001314s ]