SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526613 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526613 [ RunTime:0.003060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231798,514461,525254,213384,922049,313094,981119,29944,133512,364188,183285,999870,992953,485018,844681,471131,154216,300020,366672,878876,49000,335414,389922,405004,764285,1043974,701517,402823,586146,598954,10678,421846,796391,123408,492277,976064,749412,581904,777713,1048392,406920,702190,749503,880435,499702,263663,578993,655669,738680,936722,989171,544982,348009,790914,580489,319483,498634,232926,678844,138678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]