SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291789 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291789 [ RunTime:0.003890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317287,840116,447176,839499,102982,124592,980366,111071,939541,146874,655362,612082,141322,1024343,651800,772624,88029,355571,130624,851398,140989,649683,196139,646251,750724,633923,109099,125817,502096,362859,574158,144387,324494,597262,1006964,1005967,151190,512230,218800,286375,238745,86113,620420,487609,450609,720258,506032,225344,27238,541333,896930,728246,219009,199142,985909,261264,592056,430083,157314,576184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291789 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291789 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]