SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560475 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560475 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907044,104813,415124,844542,805208,633044,1015325,226510,706428,466298,345454,715150,699257,76806,88473,456950,714759,895752,924499,646896,600514,818032,1000579,958561,616794,31456,577166,660543,609827,858684,94820,121166,25200,323038,927420,409924,474226,331209,513241,320564,207575,713404,249907,453853,883481,370945,304517,186938,709711,756151,276419,382595,724229,1046395,457538,157686,137323,752868,13855,940729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]