SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36144 LIMIT 1 [ RunTime:0.000813s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36144 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422257,912229,275108,1561,623044,829831,224049,374231,462637,69176,651258,488241,975733,76823,131210,395821,766232,1032222,264461,636939,601434,324415,765250,322365,759490,788032,984021,127557,993828,715582,294460,652876,350249,1048176,1031200,897517,949997,249617,72432,696377,436711,378734,985657,448912,457121,840916,1032232,25960,302775,551449,633197,113446,653931,569253,94817,466078,536943,670548,965867,87322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]