SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504315 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504315 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674485,755412,369722,588228,650917,864352,957596,868702,34348,346426,387691,475754,758132,982919,662468,871148,514816,172173,194585,934216,640008,700748,438970,401306,668145,231325,250455,219024,949213,756869,858845,64677,1019933,569940,132465,566579,833316,738698,756177,720907,602555,556517,749646,1012638,1011851,763225,811045,622065,286395,301573,310266,949532,601892,1043403,919145,832027,366549,808006,261594,422492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]