SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422982 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422982 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011058,489847,137612,190385,331970,999723,804803,37264,519383,557526,740288,420573,684971,740958,539901,568897,482157,914274,451036,759914,301586,604216,584549,541242,784,472759,603864,967450,803475,948301,51155,340065,647385,39576,48900,174192,436688,553988,546434,503166,158738,479130,115711,1443,835992,343829,233118,680749,660772,480249,136044,95286,834061,928081,602848,510262,36629,549121,562894,477445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]