SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479883 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479883 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853173,883409,61291,371644,12049,421333,772890,880251,844304,205795,16094,716745,353270,489267,844441,844152,528537,238050,575633,1026909,197327,474787,659738,924696,53604,1031068,306181,327740,167659,383500,864761,431947,772398,124829,958481,213604,495908,991479,329280,72092,667375,566022,240756,720628,57469,542005,20380,701338,199795,38304,1019147,1015128,345577,770566,852740,36086,810597,28349,145514,633940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002263s ]