SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114188 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114188 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619156,249469,183785,83297,325593,201520,171602,1415,729807,269525,54342,722089,729345,145462,795735,550264,905257,445527,621429,668232,236582,759108,296863,678216,146228,310188,717015,624950,401831,588517,1037954,459328,660407,308385,187553,329751,961365,65197,151008,174236,572874,237564,700245,194922,136081,715545,805911,174345,144922,462243,984044,411578,33457,194457,802790,337440,790459,357796,119984,1039734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]