SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336420 LIMIT 1 [ RunTime:0.001137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336420 [ RunTime:0.007156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025885,576781,215932,784776,123582,852952,130732,608944,949816,843911,491536,117585,175365,5264,679526,676150,71695,194658,320822,262763,956475,837282,70946,981739,281129,206137,922109,616163,656972,990376,695140,164007,891480,54028,910014,521155,158974,100261,980052,620117,62292,510390,211596,29487,1047211,614858,514345,1045783,483764,728295,780019,992968,33455,1006414,235247,838878,1006286,719140,446542,508456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]