SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044423 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044423 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507417,550223,481461,353686,996870,581576,59082,574282,257761,69124,98961,650752,59370,313341,421343,979611,297183,709657,877189,236344,241997,705050,515,70018,321497,583221,349523,675057,715476,832339,687170,410891,1026603,173458,913822,306300,718615,676650,216098,827125,897048,140311,651959,374582,56893,808057,672886,395065,514973,468658,624588,1021230,83234,300346,281682,256361,435132,945130,67199,79891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]