SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499752 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499752 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414687,310523,206970,837030,948070,1020952,728513,461257,977608,909112,153785,147570,761490,203935,441293,40381,238233,299156,395052,375286,610713,372813,827599,760912,606299,837514,76142,648860,719145,277425,164753,827039,564651,99733,51585,508871,368393,641242,88243,673603,890402,811698,532041,983257,417406,691126,127916,481122,825291,447106,834556,552326,613778,672244,84417,518175,1032367,960339,637729,966419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]