SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534648 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534648 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833683,547807,1010076,751618,818281,294009,977452,843806,932147,1012587,486765,404485,212035,157046,529862,221737,34418,326679,920893,441265,672431,825561,301026,861430,433045,259258,681619,716915,306276,735500,538956,537606,283498,579892,801846,630774,138405,983684,507031,987875,590354,117881,435396,57228,237051,177501,999329,277889,436890,50464,31804,110332,420949,787617,135506,944339,398945,781176,277211,869415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]