SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505831 LIMIT 1 [ RunTime:0.001271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505831 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530685,819681,402772,1046511,53521,92460,557104,631186,891006,942594,1039193,1042188,778277,119893,735020,903588,220707,206975,488004,841511,452673,884532,847413,850125,256700,351980,484088,694958,585428,534082,743545,936563,516415,783942,52844,590465,111362,856496,355595,689961,190647,445492,703826,629958,131603,586167,448060,883988,750287,56010,330587,108384,628757,970452,122827,217109,490598,664118,454461,228745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]