SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005957s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501974 LIMIT 1 [ RunTime:0.002647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501974 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197625,876218,611459,707572,360567,566405,650948,989473,574316,352032,725249,626267,923395,391931,611253,188074,402031,950573,103113,584987,327854,319623,646600,525078,1040177,609060,761752,1022015,167826,954885,661887,577593,263340,149722,508897,873899,261634,124435,1029576,80358,169819,569568,289422,220811,101153,657473,718898,558669,1004627,636126,813126,366388,97759,548654,449670,209317,563445,989871,535121,521487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]