SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037512 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037512 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575936,386611,596974,652029,850943,114911,791748,114040,317052,144809,481075,1026148,568642,41691,415682,634798,526280,534857,467469,47309,621104,275804,688636,931992,221989,868071,765908,545132,284902,937296,310055,370733,938934,84731,946944,627163,17099,419088,1029120,720249,722116,618944,658722,830278,849416,659107,662345,539197,840502,433946,71295,434706,1031298,496432,967563,823461,268401,679178,830923,952516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]