SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436251 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436251 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120634,848094,380741,37813,411409,104590,361751,741815,543062,1001537,35193,113212,170148,361186,297224,873812,682451,739123,927339,1014688,931693,743541,196614,904420,111560,22534,533761,399280,524351,202658,363584,102946,973681,431777,909994,104844,80186,388328,271103,517284,530940,167023,796764,176109,434309,270065,38493,606528,32390,374561,940379,509948,606607,611892,341943,182042,1012944,817463,605874,521088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]