SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982194 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982194 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408794,619872,1100,88790,861636,865743,259196,316447,275833,771263,574635,1032063,630053,621341,397320,274351,748456,383195,768849,88160,927970,925276,450482,519452,400253,836310,482505,154274,664542,973596,385913,776564,79678,941074,693526,776479,590700,212367,205173,638895,823957,39247,980299,659601,675436,443311,797140,393994,272654,732057,98555,186883,205422,771882,957280,428475,215086,766714,970754,25078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001337s ]