SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498210 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498210 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986634,386626,232628,444099,341813,833460,105528,574835,355449,58833,593921,619865,315161,800512,1024303,335007,896019,698501,617094,569154,545402,638667,275351,539549,685882,614477,863778,350790,424445,516865,880237,558943,874898,475938,984668,5958,929365,946620,859455,463480,617477,908509,538407,229140,261607,214041,60476,1033559,464973,56464,345922,619029,873194,318445,868274,769292,690479,253557,152890,334531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]