SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470046 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470046 [ RunTime:0.001336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604914,1028104,323635,138837,449365,271337,203885,33022,1011252,990255,525517,712367,725950,955526,566123,302286,687194,143478,924876,512026,94212,519969,658663,877675,109168,275128,580642,654406,10502,882683,570343,418593,1013388,117842,369010,268359,937896,722227,186641,994310,658399,807385,1007112,1002027,983786,14748,39192,571857,156136,686842,684694,793828,55683,771568,526061,373119,899920,940020,750747,118954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]