SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300093 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300093 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812344,288761,1019842,984750,58114,857634,1038012,49238,635411,247804,309742,288501,455436,736968,260967,389422,326585,41406,1036723,992587,377534,721227,826882,342883,263787,27792,270932,187283,919791,946397,852713,417583,323437,569430,492903,226762,61043,475898,745517,36999,786872,1003986,394030,865371,687542,849723,223420,209710,627418,963298,72251,280789,261878,153356,152207,976810,522443,1017451,449127,852582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]