SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487281 LIMIT 1 [ RunTime:0.000865s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487281 [ RunTime:0.003228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047954,951844,530975,381802,1021580,919962,852695,592754,245061,963432,172977,664627,294692,645894,214357,293899,1014259,247603,688419,739242,442065,768152,291210,162304,204131,105739,754265,669586,679095,227976,1017908,712325,341651,854786,972182,809532,153579,12934,333879,28423,469141,562278,573652,213339,1043068,495616,864005,544997,311883,892101,1002736,1021791,456194,258123,947964,19977,646003,678351,495702,181390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]