SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281423 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281423 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83108,115937,502680,293580,910227,104895,723645,107491,678215,403167,339836,947502,387009,510394,88943,121747,711701,100837,952363,68161,588454,590081,207732,504596,45897,1016337,139826,481699,115193,898308,1024756,610672,529821,857563,1008687,613639,723718,912303,982001,21095,521918,438310,69279,934414,60440,949709,451447,333620,217265,77474,922812,816001,572771,991915,454776,841210,371707,992698,674697,454927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]