SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 864512 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 864512 [ RunTime:0.003700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433413,498514,116714,183061,251767,85987,100465,1028915,83791,649225,998151,470393,452414,952378,960373,65584,283003,218247,853053,383472,89754,207329,786905,999083,90077,307315,700570,955229,437840,321026,670502,27275,593072,852376,517197,401314,692365,1016583,855115,382020,1027045,732382,548917,681823,974134,509697,700309,73366,384739,510240,402016,443979,649395,343458,990850,887651,643696,720581,309469,628478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 864512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 864512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]