SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530419 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530419 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000188,1011101,952228,260611,197178,570893,589623,892117,651113,799392,450949,284407,89408,845676,938844,359966,919618,13821,602279,1000194,105290,707630,190991,805729,282086,590206,195560,1046549,739186,303702,140510,489710,959900,898558,939785,269142,62904,55962,720789,304696,183565,458855,270793,87602,816739,381332,874923,94439,430356,721143,687934,570598,23797,139288,76274,571081,330042,1021162,614454,175635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001077s ]