SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535440 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535440 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530332,693951,130353,457811,681057,928672,158237,1039029,559649,469036,243997,743174,150305,293742,749481,337032,603244,669187,521862,1032552,67382,603949,548655,1035326,639317,416202,52708,730851,133829,488563,816933,246255,312157,690602,526790,438573,473365,769321,850021,739981,236485,963223,745713,539920,26973,671422,247074,678293,338633,74049,593004,124430,936222,208312,658439,23594,65266,797214,807222,991744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]