SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503584 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503584 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459361,1008500,751974,63237,312996,247829,330806,967021,551671,359395,472644,750609,654835,483094,609506,940546,467199,436288,413610,365929,304635,123885,557940,899720,762177,60760,778758,217174,697623,891348,1011572,988027,886680,602719,396779,304611,222507,22550,302922,704483,403917,315994,807851,834605,367670,330961,958886,544461,746728,160924,469284,395894,324423,264411,762659,923966,78952,43912,159041,812906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001076s ]