SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282011 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282011 [ RunTime:0.002984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972221,918769,68054,736970,323659,1022008,299637,537418,619193,330561,10236,329617,439289,971168,13144,158702,205275,997846,834845,14251,688166,576478,119447,750928,860464,452799,1019944,979373,192054,1003292,799565,16915,502164,261405,1012274,808298,532376,996905,706771,68484,740070,809415,192230,125314,278411,478175,26340,667457,240261,495400,872657,461839,132882,737432,323552,828538,621600,220960,825983,539714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]