SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014753 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014753 [ RunTime:0.006008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244509,935798,164906,264959,147501,740420,856880,80777,318188,428516,409514,221240,784132,797102,514925,173021,861597,830197,166467,615131,748271,833808,733710,402679,56320,470782,361224,984780,601416,701445,768192,413493,499424,694790,199458,461894,223250,968913,572193,611106,661881,375464,397552,835166,1012495,539055,34484,937011,588230,178226,227894,741088,470071,418650,686869,232149,437789,723570,357754,717625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]