SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343819 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343819 [ RunTime:0.005614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823061,296134,441988,173558,939531,972291,543251,93713,45742,413463,398887,293862,542237,376893,142030,743484,222201,740450,124960,197705,988964,711082,1010423,553666,753631,106090,201041,2336,769544,451411,230787,716495,73870,592636,955866,1030768,426616,751686,757431,1025588,775375,301913,342441,263227,685310,471195,684321,684819,540481,337948,190578,946570,50283,833006,577328,623955,773735,869330,364391,474381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]