SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524015 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524015 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922750,275145,459311,584056,64586,869109,596913,907553,713171,181366,504275,897191,275010,1010586,105545,731545,499479,115354,276318,780232,19531,316655,252483,154214,457295,820878,34438,880890,444257,340984,504344,754404,429181,1005295,733000,752238,392423,508680,909786,191219,128049,763092,843410,295162,640034,76743,690105,638425,845957,400529,101131,540673,675514,843393,170676,938345,978904,163339,606559,547619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]