SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500164 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500164 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499487,448768,400677,480244,125166,1016964,401294,103189,377956,14340,938934,996838,615225,185114,659051,77036,370206,538579,223494,1018403,946315,472122,724072,1019163,216956,556181,175661,249238,207275,942234,777437,156143,615309,961598,581813,852182,71301,479872,927513,225374,505730,966704,19011,1012372,131100,772836,865007,797540,245753,823844,492939,621905,625823,50513,771712,165183,594280,807815,687595,436611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]