SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5397 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5397 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782800,179888,866853,1711,569919,244568,15243,816930,757196,962636,972089,333386,906410,683932,536185,33754,240586,249753,238167,81729,946194,650963,509488,513480,799010,316137,13968,8820,135964,523348,800981,832947,1036427,379721,104962,1038603,444042,132247,114092,394000,567252,968588,885796,628411,841169,1048539,214926,813953,803635,166851,135708,541510,81972,720514,246621,888835,791947,275538,791173,710106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]