SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501793 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501793 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167459,27565,651400,672626,706700,730069,757946,426538,372012,14238,821869,311336,804075,828644,744630,268667,794369,59442,500388,634063,217851,601111,1023653,836230,317680,1007333,1020286,725887,659493,256364,919863,557157,842395,123057,8135,515569,835547,941987,890427,392999,772780,657672,330900,22316,915858,699944,313843,1003706,575593,666716,851548,209012,546661,229032,215764,381774,118516,841136,269636,466861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]