SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501785 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501785 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539285,1009693,683718,526733,513441,823516,73309,974942,763683,88181,149982,981413,103484,524545,789369,733923,540041,707423,694235,963676,108894,853927,1014551,825450,842659,427348,160193,828346,14075,323101,548634,854386,515853,116454,348679,394926,871502,324043,517711,114687,819642,967072,493400,41810,530624,4657,245225,486813,203773,1003015,22498,139541,702535,10498,443736,534888,957519,156285,750613,570926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]