SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482035 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482035 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433404,1043456,517195,195593,734015,492139,521988,610459,423733,664233,165587,1042644,371005,801815,223863,791133,476932,462558,969440,73675,443297,252625,36738,731161,115238,317209,949816,91584,633421,44768,124625,546153,304630,295909,806205,658096,1029732,902377,726754,614739,498064,437094,26282,554495,294704,861477,890540,224515,96850,516999,244141,157825,292948,410995,108145,898309,266076,662171,793130,165558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002230s ]