SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472905 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472905 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277132,897076,781533,233708,732978,1000868,450991,540141,1010235,1038821,377105,941384,839019,815110,234606,879365,310021,348489,363899,29416,624361,210140,250746,395838,108576,821774,1042519,762919,727470,705104,97623,568363,783427,443103,322799,682718,473545,381883,371154,131246,59301,364225,950270,971570,353421,503520,1019195,719256,807020,31942,713446,508417,790420,276358,1001847,593260,319147,705396,702401,546428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]